﻿CREATE TABLE [dbo].[WarehouseRelease] (
    [Id]                 UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [RefNumber]          NVARCHAR (50)    NOT NULL,
    [RequestorId]        UNIQUEIDENTIFIER NOT NULL,
    [ApproverId]         UNIQUEIDENTIFIER NULL,
    [GoodCondition]      BIT              NULL,
    [CorrectQuantity]    BIT              NULL,
    [NotReleased]        BIT              NULL,
    [ReceivedBy]         NVARCHAR (250)   NULL,
    [ReceiverTitle]      NVARCHAR (250)   NULL,
    [ReceivingUnit]      NVARCHAR (250)   NULL,
    [ReceiptDate]        DATE             NULL,
    [ReleasedBy]         NVARCHAR (250)   NULL,
    [ReleaserTitle]      NVARCHAR (250)   NULL,
    [ReleaseDate]        DATE             NULL,
    [CountryProgrammeId] UNIQUEIDENTIFIER NULL
);

